Re: Updatable views - Mailing list pgsql-patches

From Bernd Helmle
Subject Re: Updatable views
Date
Msg-id A9E9043BA2C435A74FD442A6@[172.26.14.247]
Whole thread Raw
In response to Updatable views  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: Updatable views  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: Updatable views  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-patches

--On Montag, August 21, 2006 02:07:41 -0400 Alvaro Herrera
<alvherre@commandprompt.com> wrote:

> Hi,
>
> This is the patch for updatable views I've been able to come up with.  A
> nasty bug was just discovered in the upcoming Mammoth Replicator release
> so I'm not sure if I'm going to have time to work more on it soon.
>
> So, I'll appreciate if somebody else takes the responsability to fix the
> remaining issues.  I've put a lot of XXX's and some FIXME's.
> Some
> functions are in need of some comments as well.
>

I'll try to complete the missing comments and to make some statements
cleaner.

> The new files are src/backend/rewrite/viewUpdate.c and
> src/include/rewrite/viewUpdate.h.  The third file, upd-views.sql, is
> intended to be a new regression test.  Extra points if the table therein
> is completed correctly.
>
> I haven't tested the array stuff at all.
>
> Comments from Bernd and Jaime are especially welcome if I've broken
> something that used to work on their patch :-)

I see that the current patch doesn't support subqueries in the WHERE-clause
anymore.
You can find one example in the attached SQL-script. Is there a reason why
you
dropped this?

--
  Thanks

                    Bernd

Attachment

pgsql-patches by date:

Previous
From: "Albe Laurenz"
Date:
Subject: Fix linking of OpenLDAP libraries
Next
From: Alvaro Herrera
Date:
Subject: Re: Updatable views